If you attempt to update the SAS^® Metadata Repository for a view using PROC METALIB or the Update Table Metadata feature in SAS^® Management Console you will receive errors similar to the following:

The errors occur because the libref that is used to reference the contributing data sets or views is stored with the view definition when the view is compiled. When the PROC METALIB executes, it assigns the view library using the reserved libref _PMTA01_. When PROC METALIB tries to open the underlying data set or view, it cannot because the libref stored within the view is not assigned.

You can circumvent the problem using one of the following methods:

• explicitly add a LIBNAME statement to the application server's autoexec.sas file to ensure that the library is assigned using the libref that is stored in the view definition
• include the USING LIBNAME clause in the definition for views created using PROC SQL to allow the library to be assigned using the necessary libref at execution time

Operating System and Release Information